﻿using System;
namespace BZZ.Model
{
	/// <summary>
	/// 友情链接实体类：links 。
	/// </summary>
	[Serializable]
	public class links
	{
		public links()
		{}

		#region Model
		private int _id; //id
		private string _linkName; //名称
		private string _gotoUrl; //网址
		private string _title; //title
		private string _about; //说明
		private DateTime? _updateDate; //到期日期
		private int _status; //状态
		private string _ext; //扩展


        /// <summary>
		/// id
		/// </summary>
		public int id
		{
			set{ _id=value;}
			get{return _id;}
		}
        /// <summary>
		/// 名称
		/// </summary>
		public string linkName
		{
			set{ _linkName=value;}
			get{return _linkName;}
		}
        /// <summary>
		/// 网址
		/// </summary>
		public string gotoUrl
		{
			set{ _gotoUrl=value;}
			get{return _gotoUrl;}
		}
        /// <summary>
		/// title
		/// </summary>
		public string title
		{
			set{ _title=value;}
			get{return _title;}
		}
        /// <summary>
		/// 说明
		/// </summary>
		public string about
		{
			set{ _about=value;}
			get{return _about;}
		}
        /// <summary>
		/// 到期日期
		/// </summary>
		public DateTime? updateDate
		{
			set{ _updateDate=value;}
			get{return _updateDate;}
		}
        /// <summary>
		/// 状态
		/// </summary>
		public int status
		{
			set{ _status=value;}
			get{return _status;}
		}
        /// <summary>
		/// 扩展
		/// </summary>
		public string ext
		{
			set{ _ext=value;}
			get{return _ext;}
		}
		#endregion Model

		#region txt document
		/*
友情链接,links
id,名称,网址,title,说明,到期日期,状态,扩展
id,linkName,gotoUrl,title,about,updateDate,status,ext
i,c100,c256,c256,c400,d,i,c100

--------------------------
-- 创建表[友情链接]开始: 
-- alter table  [BZZ_links] add
-- IF EXISTS (SELECT 1 FROM sysobjects WHERE xtype='u' AND name='BZZ_links') drop table BZZ_links
  CREATE TABLE [BZZ_links] (
	 [id] integer IDENTITY (1, 1) PRIMARY KEY NOT NULL ,
	 [linkName] [varchar] (100),
	 [gotoUrl] [varchar] (256),
	 [title] [varchar] (256),
	 [about] [varchar] (400),
	 [updateDate] [datetime],
	 [status] int,
	 [ext] [varchar] (100)
  )

 exec sp_addextendedproperty N'MS_Description',N'友情链接 ',N'user',N'dbo',N'table',N'BZZ_links', NULL, NULL
 exec sp_addextendedproperty N'MS_Description',N'id',N'user',N'dbo',N'table',N'BZZ_links',N'column',N'id'
 exec sp_addextendedproperty N'MS_Description',N'名称',N'user',N'dbo',N'table',N'BZZ_links',N'column',N'linkName'
 exec sp_addextendedproperty N'MS_Description',N'网址',N'user',N'dbo',N'table',N'BZZ_links',N'column',N'gotoUrl'
 exec sp_addextendedproperty N'MS_Description',N'title',N'user',N'dbo',N'table',N'BZZ_links',N'column',N'title'
 exec sp_addextendedproperty N'MS_Description',N'说明',N'user',N'dbo',N'table',N'BZZ_links',N'column',N'about'
 exec sp_addextendedproperty N'MS_Description',N'到期日期',N'user',N'dbo',N'table',N'BZZ_links',N'column',N'updateDate'
 exec sp_addextendedproperty N'MS_Description',N'状态',N'user',N'dbo',N'table',N'BZZ_links',N'column',N'status'
 exec sp_addextendedproperty N'MS_Description',N'扩展',N'user',N'dbo',N'table',N'BZZ_links',N'column',N'ext'

-- 创建表[友情链接]结束。 
--------------------------

		*/
		#endregion document
	}
}

